A British Brexit-backing Tory MP who described the prospect of leaving the European Union with no deal as "the real n***** in the woodpile" has apologised.