By the end of this century, sea level rises alone could displace 13m people. Many states will have to grapple with hordes of residents seeking dry ground. But, as one expert says, ‘No state is unaffected by this’