Weather warning issued as thunderstorms and ‘torrential’ rain forecast for Scotland