The Tory MP at the heart of a Westminster sexting scandal has stood down from two top Commons posts.