Houston was ranked the second most affordable major city in the country for renters by a new analysis in which Redfin compared the median apartment rent to the median income of renter households.