Robots will create more jobs than they replace, although many roles will become redundant, a report says.