The top five states with most residents leaving are all led by Democrats, CNBC reports