Lord Callanan, who was appointed a Brexit minister last month, has been forced to apologise for telling peers that Article 50 could not be revoked.