The warm weather is set to change and get more autumnal after a final burst of summer