A rare red alert for "very strong" wind has been issued for parts of the UK ahead of Storm Eowyn.