At least 24 people are reported to have died after a Spanish train derailed, toppling passenger cars on their sides and leaving at least one torn open as smoke rose into the air.