Australia has won its bid for a United Nations Security Council seat after securing 140 votes in a secret ballot.