All paragraphs are indexed in the paragraph tag. What you can do is query that, filter by the page name, order by pos (the position in the page) and then limit to the first result.
This is how you can do that in a template:
{{#let @pageName = name}}
{{at({paragraph where page = @pageName order by pos limit 1}, 0).text}}
{{/let}}