First-time buyers drove a largely stagnant mortgage market in August, with the latest figures showing this demographic hit its highest level since June 2017.