In addition to jack's comments.

why dont you user in or bigint and you can use identity as well.

Index will have greater effect on usage of between.