Pieces of a Myanmar military plane which went missing with more than 100 soldiers and family members aboard are found in the Andaman Sea, a local official says.