The heat is expected to give way to instability in Scotland, with a growing risk of thunderstorms and a chance of flooding and disruption.