How to auto-increment into other columns

Question

my question is

how to sum and auto-increment into other column when we insert into column 1

 

id	Column1(Inserted)	column2(Auto-increment column)
1	10	10
2	10	20
3	20	40
4	30	70

 

how to perform this and what is the query for this kind of result