Councillors heard the significant demand was driven by the cost of living crisis and the challenging private rent sector