There is more than one way to achieve what you describe. I find the following works with Windows 7/LO 6.0.6, and as far as I know all earlier versions.
1 Put the cursor at the end of your title page. Insert a page break by selecting Insert>Manual Break.
2 This will open a dialogue box. Make sure “Page Break” is checked and enter the name of the page style you will be using for your script (very likely Default), then check the “Change page number” box and set the first page number you want in the box below it. Click on OK.
3 Modify the Default page style to your liking. Make sure this includes “Header on” and that “Same content on first page” is unchecked (but see 5 below on creating a Title Page style).
4 Put the cursor in the header area of your second page, in the position where you want your numbers. Select Insert>Field>Page Number. Your first page number will probably appear, but if some words appear select View>Field Names to toggle between the name of the field and its effect.
Some points to note
5 You can create your own “Title page” page style and change your first page to that. This will give you more freedom to produce a layout that doesn’t have a header and won’t be affected by changes to the page style used for the rest of your script. If you do this, it seems best to have “Same content on the first page” in the Manual Break dialogue box checked but this doesn’t seem to make any difference on my system.
6 If you don’t know how to manage page styles read Chapter 8, “Introduction to Styles” in the LO 6.0 Writer user manual. You can download this as a PDF, free of charge, from the LO website’s documentation page (English documentation | LibreOffice Documentation - Your documentation for LibreOffice). To open a list of styles select View>Styles (in Windows F11 should open it too, but I think Macs use a different shortcut). Click on the fourth icon in the row at the top to open the list of page styles.
7 To create a template for future scripts see Chapter 10 of the LO Writer 6.0 manual.
8 You can make a variety of adjustments to the page number position by modifying the style you are using for the text pages (e.g. have odd numbers on the right and even on the left for double sided printing, though to get everything right you might need to insert a blank page for the rear of the title page). You will need to figure out what is right for you.
I hope this helps.