Nigel Farage, the most prominent campaigner for Britain to leave the European Union, says he is warming to the idea of a second Brexit referendum.