Rising mortgage rates have had a significant impact on mortgage affordability, which is now at its weakest level in 15 years, a credit rating agency said.