Hundreds of homes built for the Commonwealth Games in Birmingham are being sold off by the council at a projected loss of more than £300m, in a situation branded "nothing short of a scandal".