British people should have the option to stay within the EU when negotiations end, the new Liberal Democrat leader Vince Cable says.