copy one field from table to another field in the same table
Single-quotes are for strings.
Try backticks instead, e.g.:
UPDATE `content_type_chapter` SET `field_chapternumbersort2_value` = `field_chapternumbersort_value`
The backticks aren't strictly necessary, though.