A Met Office yellow weather warning for thunderstorms and heavy rain covers most of Scotland following the recent hot spell.