Trees uprooted and debris scattered across courses in worst storm to hit Scotland since 1998