It was the storm of the century, an unstoppable force of nature which swept across Scotland leaving devastation in its wake.