Scandal-hit peer Lord Sewel has resigned from the House of Lords after coming under intense pressure over footage of him allegedly taking cocaine with two prostitutes.