A weather phenomenon described by the Met Office as the UK's 'most explosive' is on the cards in the coming days, with heavy rain and thunderstorms expected