According to the reviewer’s report the research paper can be accepted for publication in the present form. After sending the research paper for reviewing, the editor has changed. The new editor asks for some more results.
The editor's decision is final and overpowering. I would suggest you work on the recommendations of the editor because in the end he only can accept your paper for publication.
The reviewers usually give useful comments on all papers as you have had already supportive comments from reviewers.
If there is any such adjustment of editor's recommendation then try to do the same in order of editor's decisions otherwise better to apply your paper in some other journal as the decision of the editorial board is final .
The comments given by the genuine reviewers and/or editor(s) always support to improve the status of an article compared to that of its previous version. A significantly improved article would add more value to your research than accepting as it was in its initial version. That's what we expecting from a genuine peer-reviewed journal. Sometimes it is frustrating to see a plenty of comments made by the reviewers and/or the editor of the target journal. However, taking them openly/positively and addressing them correctly would ultimately lead you to have a fruitful article in your hand. So, do not think about the sudden change of the editor, incorporate the suggestions unless they are absolutely unrealistic.
Normally what happens is, if the reviewers have accepted the paper in the present form with minor modifications, then the paper is accepted with all due respect to the reviewers. The editors may not be the subject experts, but the reviewers are the subject experts. Hence editors have to respect the reviewers judgment. If this not happening its an unfortunate situation where editors have crossed the line. Anyway the final publication authority is with the editors.