A councillor says Bristol is now the UK's most expensive city to rent outside of London with many struggling to pay.