The Met Office has issued a maximum red warning for parts of the UK due to the 'exceptionally strong northwesterly winds' expected