The reviewers independently evaluate the manuscript and advise the editor whether the manuscript is worth publishing in the journal. Generally speaking, it is not necessary for all reviewers to accept this paper. But it depends on the specific policies of the journal. Some journals may tend to get unanimous approval from reviewers, while others need a majority.
The editor will consider the feedback from all reviewers and make an informed decision to accept or reject the manuscript. In some cases, if the proportion of opinions accepted and rejected is equal, or if the editor is not satisfied with the reviewers' opinions, the editor may consider sending them to other reviewers.