People living in Scotland and Northern Ireland have been advised to stay home following red weather warnings due to Storm Eowyn's wrath.