Met Office warns UK weather finally turns this week following one of warmest springs on record and driest start to season in nearly six decades