The Church of Scotland has voted in favour of allowing people in same sex civil partnerships to be called as ministers and deacons.