The sql Harsh provided didnt provide the count. ident_incr - is the incremental value
Try this - this is not much different to what Harsh provided except it shows all columns
COLUMNPROPERTY(object_id('Orders'),COLUMN_NAME,'IsIdentity') AS IsIdentity,
IDENT_INCR('ORDERS') AS INCREMENT_VALUE,
IDENT_CURRENT('ORDERS') AS CURRENT_VALUE
WHERE TABLE_NAME = 'Orders'
Beauty is in the eyes of the beerholder