Spain’s meteorological agency, said Valencia had seen ‘the most adverse cold drop of the century’ prior to the floods