Storm Hector destroys VIP tent on Scottish Open golf course