the maximum is given by the carnot cycle, which has COP=T_high/(T_high-T_cold) so from room temp 25°C to 250°C it is 2.3, but this is the theoretical limit
Which is why for some pool heat pumps you get claimed numbers of around 9, with the fine-print that the air temperature has to be higher than the water temperature.