A metro overpass has collapsed in Mexico City as a train was travelling over it, killing at least 23 people, including children, the mayor said.