seriously.

if you are talking about plot numbers on a building site, then a plot "number" is not a number. It's text. Sometimes you will have suffixes. eg plot 1A, 1B etc. You also do not need to do any arithmetic with plot numbers. Because it's text. This is the same treatment as phone numbers - They are text as well.

I would 100% treat your plot "numbers" as text fields.

The method you choose for handling a group of plot numbers, is going to be similar to, say, the way you select pages for printing on a report.

eg 1-4, 6

This is nothing to do with whether the numbers are stored as numbers or text, more to do with presentation, and data manipulation.

I am surprised you need the prefix zeroes, but if you treat the numbers as text, then plot 0001 is just that. Plot "0001" and the leading zeroes are just text characters. One benefit of storing the leading zeroes is that "natural" sorting becomes consistent because of the fixed number of characters.

you get 0001,0002, 0002A, 0002B, ..., 0010, ..., 0100

whereas if you sort without the leading zeroes you get a different "natural" sort order

1,10,100, 11, 2, 2A, 2B etc