A “miracle escape” was how shocked witnesses described the mini-tornado which caused the collapse of a large section of the roof in Cork train station.