The massive demand for council housing saw one address in Rowley Regis receive more than 1,500 bids last year