The Foreign Office has warned European Union holidaymakers in the wake of parts of Spain issuing an urgent red weather warning for the country.