Met Office forecasters have warned that major disruption could be coming to six areas covered by its latest yellow weather warning, with thunderstorms on the cards