Ronen Hoffman becomes second Lapid-appointed ambassador to resign, explaining that 'my personal and professional integrity has compelled me to request to shorten my post'