How to change order no from 10000* to new

With this code your order no will be started from 1001. If  you want to add prefix then you can add
eav_entity_store.increment_prefix='ABC' you have to add length to.

update eav_entity_type set increment_pad_length=4 where entity_type_code='order';
update eav_entity_store inner join eav_entity_type on eav_entity_type.entity_type_id = eav_entity_store.entity_type_id set eav_entity_store.increment_last_id='1000',eav_entity_store.increment_prefix='' where eav_entity_type.entity_type_code='order';

update eav_entity_type set increment_pad_length=4 where entity_type_code='invoice';
update eav_entity_store inner join eav_entity_type on eav_entity_type.entity_type_id = eav_entity_store.entity_type_id set eav_entity_store.increment_last_id='1000',eav_entity_store.increment_prefix='' where eav_entity_type.entity_type_code='invoice';

update eav_entity_type set increment_pad_length=4 where entity_type_code='shipment';
update eav_entity_store inner join eav_entity_type on eav_entity_type.entity_type_id = eav_entity_store.entity_type_id set eav_entity_store.increment_last_id='1000',eav_entity_store.increment_prefix='' where eav_entity_type.entity_type_code='shipment';

update eav_entity_type set increment_pad_length=4 where entity_type_code='creditmemo';
update eav_entity_store inner join eav_entity_type on eav_entity_type.entity_type_id = eav_entity_store.entity_type_id set eav_entity_store.increment_last_id='1000',eav_entity_store.increment_prefix='' where eav_entity_type.entity_type_code='creditmemo';