A rare red weather alert has been issued for parts of the UK