The record-breaking UK heat experienced in 2022 will be regarded as a cool year by the end of this century, the Met Office says.