The Met Office has issued a yellow thunderstorm warning for Southampton with heavy rain expected.