AGN-host connection at 0.5 < z < 2.5: A rapid evolution of AGN fraction in red galaxies during the last 10 Gyr