People across Scotland and Northern Ireland have been left startled after receiving a 'weirdly apocalyptic' emergency message ahead of Storm Éowyn.