On the other end of the scale, Birmingham has been named the least environmentally friendly city, according to a new study