Scotland is braced for what could be one of the worst storms in recent memory, as extremely rare Status Red weather warnings have been issued across Ireland and Britain.