I would not worry too much about your manuscript matching the exact output of published papers in the journal you are submitting to as long as you follow the submission guidelines, use the template suggested there and do not do anything crazy (LaTeX wise).
In any case a document using the revtex4-2 class is incompatible with biblatex (and thus biblatex-phys), since the class loads natbib. natbib and biblatex cannot both be used in the same document. So solutions using biblatex or biblatex commands like \AtEveryBibitem are out.
From reading https://journals.aps.org/prb/authors and inspection of the example files that come with revtex (https://www.ctan.org/tex-archive/macros/latex/contrib/revtex/sample/aps) here is what I gather you should use
\begin{filecontents}{\jobname.bib}
@book{elk,
author = {Anne Elk},
title = {A Theory on Brontosauruses},
year = {1972},
publisher = {Monthy \& Co.},
location = {London},
}
@article{sigfridsson,
author = {Sigfridsson, Emma and Ryde, Ulf},
title = {Comparison of methods for deriving atomic charges from the
electrostatic potential and moments},
journal = {Journal of Computational Chemistry},
year = 1998,
volume = 19,
number = 4,
pages = {377-395},
doi = {10.1002/(SICI)1096-987X(199803)19:4<377::AID-JCC1>3.0.CO;2-P},
}
\end{filecontents}
\documentclass[%
reprint,
amsmath,amssymb,
aps,
prb,
]{revtex4-2}
\usepackage{hyperref}
\begin{document}
Lorem \citep{sigfridsson}
ipsum \citep{elk}
dolor \citep{sigfridsson}
\bibliography{\jobname}
\end{document}

Note that this does produce the title of the reference, which seems to be preferred by PRB as https://journals.aps.org/prb/authors says
Physical Review encourages authors to include titles for all references as an aid to the reader. If this format is used, it must be applied to all references. Please note that Physical Review X, PRX Energy, PRX Quantum, Physical Review Research, Physical Review Applied, and Physical Review Fluids require all references to include titles.
For all of this it does not matter at all how you generate your .bib entries (if you use Zotero or DOI2BIB) all that matters is that the .bib entries are complete and accurate (which can be hard to achieve with automatic systems, see Software-generated bibliographic entries: common errors and other mistakes to check before use, so manual checking is very much recommended).
Remember that in the end a .bib file is just a text file that you can edit directly with Overleaf if you need to.
In the example shown above the .bib file is generated automatically with filecontents. This is common in examples on this website, but uncommon in practical applications. In your real-world document you put everything between \begin{filecontents}{\jobname.bib} and \end{filecontents} (excluding those two lines) into a .bib file, say mybib.bib, and call that file in \bibliography as \bibliography{mybib} in the example where you want the bibliography to appear.