The latest data shows that smaller cities are attracting the most newcomers, while major metros have lost some of their appeal.