The Met Office issued a rare "danger to life" warning to the potentially destructive winds which could cause large coastal waves and put people at risk