Former Conservative Deputy Prime Minister Lord Heseltine has been sacked as a government adviser after speaking out against leaving the European Union and rebelling over the Brexit vote in the House of Lords.