Is it possible to translate one RAL colour into another? For example, RAL Classic into RAL Design?

No, this is not possible as the three different product lines RAL Classic, RAL Effect and RAL Design are completely separate ranges and independent from each other as they were formulated for different purposes. The software RAL Digital can be used to find the closest match to a colour from another product line.