EXCLUSIVE: A weather expert warned this last mini heatwave will be the "last of the summer wine" as autumn moves in and remains.