This is not possible by just dragging down an example. The function to use is the sequence function in Excel. We'll use a single Excel function which will repeat the same number multiple times and then start over with then next number in the sequence.
Learn 4 different techniques for creating a list of numbers in Excel. These include both static and dynamic lists that change when items are added or deleted from the list.
https://www.excelcampus.com/tips/numbered-lists/
Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
For situations such as lists that change often, with blank cells between topics that must be clearly indexed or numbered, here’s a formula that can do the job.
In the picture, a list of Excel training topics is being compiled. Later, the list is revised, and in fact the list might be revised many times. The trick is to have a formula in column A that automatically numbers the Topics as they appear in column B.