Schools shut, roads flooded and trains cancelled as thunderstorms batter north-east