A minister happy to be described as a “cheerleader for the church” has said it is humbling to be named the next Moderator of the General Assembly of the Church of Scotland.