The rare weather event comes as the Met Office issued a yellow weather warning for rain and thunderstorms this weekend