You can switch to absolute page numbers, but it's all or nothing. Also, while [plainpages] will link to page ii as 2, it will not link to page 2 as 6.
\documentclass{book}
\usepackage[hypertexnames=false]{hyperref}
\usepackage{lipsum}
\makeatletter
\newcommand\abspagenumber{\the\Hy@pagecounter}
\makeatother
\begin{document}
\frontmatter
\hyperlink{page.2}{Go to page 2}
\hyperlink{page.6}{Go to page 6}
\lipsum[1-20]
\mainmatter
\abspagenumber
\lipsum[1-20]
\end{document}
This gives you the option of linking to \thepage
or \theHpage
(absolute).
\documentclass{book}
\usepackage{hyperref}
\usepackage{lipsum}
\newcounter{Hpage}
\AddToHook{shipout/after}{\raisebox{\dimexpr \headheight+\headsep}[0pt][0pt]{\refstepcounter{Hpage}}}
\setcounter{Hpage}{1}
\begin{document}
\frontmatter
\hyperlink{page.2}{Go to page 2}
\hyperlink{page.ii}{Go to page ii}
\hyperlink{Hpage.2}{Go to Hpage 2}
\hyperlink{Hpage.6}{Go to Hpage 6}
\lipsum[1-20]
\mainmatter
\lipsum[1-20]
\end{document}