Rare red weather warnings issued for Scotland and Northern Ireland; more than 700,000 homes without power in Ireland and 2,500 in Scotland