UKIP's Nigel Farage has apologised for any offence over a comment he made saying Brexit won "without a bullet being fired" .