The Met Office has issued an amber weather warning ahead of the first named storm of the season, which is set to hit the UK on Sunday.