Rare red weather warnings have been issued in Scotland and Northern Ireland.