A yellow weather warning has been issued for thunderstorms in parts of south-west England and much of Wales, the Met Office said.