As the U.S. population continues to age, an analysis has revealed the best and worst states to grow old.