Met Office has issued a stark yellow weather warning