Rail services and flights have been axed, with rare red weather warnings issued for Scotland and Northern Ireland.