The Met Office has issued a rare red “danger to life” warning covering Glasgow and Edinburgh