Is it possible to do autoincrement

Question

i having a column name order_no and that column should be autoincremented  by 1 and i want to check if the order_no value is divisible by 3 and in next day order_no values should be cleared.how is it possible to do in oracle ?