Thunderstorms and flash flood risk on final day of UK heatwave