Home prices in major U.S. metropolitan areas rose by more than expected in the month of September, according to a report released by Standard & Poor’s on Tuesday.