What are the Pros and Cons of assigning value for ids from an offset? (Ex: 100,200,1000) Pre-dominantly, everybody uses the int data-type or it's variants tinyint,smallint and mediumint to generate a unique value for the id field of their database table(s).

I have seen so many questions, asking How to start auto-increment from a value (offset) ? When it comes to generating ids for orders table in specific, I feel everybody wants to start off from an offset.

So, in this context, my questions are: 


Is it more of a business rule? If so, how does a business rule make sense while generating numbers?
If it's an individual's decision then what could be the possible elements  to be considered while deciding to assign id's value from an offset??
Why not start from 1 for all the ids and what is the need to start assigning ids from an offset? What problem does it solve? What are the Pros and Cons of doing so?
There are a variety of reasons why you may want an offset. Please be aware, some of these reasons are not necessarily good DBA practice.


As dnoeth mentioned, your primary key may be used in some other business process such as an order number. In that case, you don't want your customers thinking they are only the 11th order!  Being order number 1100011 is much better.
You may have a old system that is in read only mode.  It has all your old customers in it with their primary keys, and you want the new system to pick up where it left off.
Same idea, you know you will be importing PKS of a certain value at some point in the future, so you start with ones you know won't cause a collision.


Personally, the only time I offset is to avoid PK collisions. Sure, there was that one time when I was younger that I just though starting at PK ID 10000 was cool, but that was a long time ago.

Really, there are no Cons of doing so.  Except for some nominal space issues between data types and potentially losing the ability to assign PKs up to the data type limit, the database doesn't care if it starts at 1 or 1,000,000. It is going to index it all the same.