Metropolitan Police Assistant Commissioner John Yates has quit over the forces involvement in, and handling of, the phone hacking scandal.